<!DOCTYPE html>
<html class="x-admin-sm" xmlns:th="http://www.thymeleaf.org">

<head>
    <meta charset="UTF-8">
    <title></title>
<!--    <meta name="renderer" content="webkit">-->
<!--    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">-->
<!--    <meta name="viewport" content="width=device-width,user-scalable=yes, minimum-scale=0.4, initial-scale=0.8,target-densitydpi=low-dpi" />-->
    <link rel="stylesheet"  th:href="@{/X-admin/css/font.css}">
    <link rel="stylesheet" th:href="@{/X-admin/css/xadmin.css}">
    <script th:src="@{/X-admin/lib/layui/layui.js}" charset="utf-8"></script>
    <script type="text/javascript" th:src="@{/X-admin/js/xadmin.js}"></script>
    <script th:src="@{/js/toExcel.js}"></script>
</head>

<body>
<div class="x-nav">
            <span class="layui-breadcrumb">
                <a href="#">首页</a>
                <a href="#">演示</a>
                <a>
                    <cite>导航元素</cite></a>
            </span>
    <a class="layui-btn layui-btn-small" style="line-height:1.6em;margin-top:3px;float:right" onclick="location.reload()" title="刷新">
        <i class="layui-icon layui-icon-refresh" style="line-height:30px"></i>
    </a>
</div>
<div class="layui-fluid">
    <div class="layui-row layui-col-space15">
        <div class="layui-col-md12">
            <div class="layui-card">
                <div class="layui-card-body ">
                    <form class="layui-form layui-col-space5" th:action="@{/student/getScoreBySportsName}">
                        <div class="layui-input-inline layui-show-xs-block">
                            <select name="sportsId" >
                                <option  name="sportsId" th:each="sports:${list}" th:text="${sports.getSportsName()}"
                                            th:value="${sports.getSportsId()}" th:selected="${sportsId==sports.getSportsId()}"></option>
                            </select>
                        </div>

                        <div class="layui-input-inline layui-show-xs-block">
                            <button class="layui-btn" lay-submit="" lay-filter="sreach" type="submit">
                                <i class="layui-icon">&#xe615;</i></button>
                        </div>
                    </form>
                </div>

                <div class="layui-form-item">
                    <button type="button" style="float: right" class="layui-btn" id="excell" onclick="method5('dataTable')">导出为Excel</button>
                </div>
                <div class="layui-card-body ">
                    <table class="layui-table layui-form" id="dataTable">
                        <thead>
                        <tr>
                            <th>名次</th>
                            <th>选手学号</th>
                            <th>选手姓名</th>
                            <th>性别</th>
                            <th>学校</th>
                            <th>项目编号</th>
                            <th>项目名称</th>
                            <th>项目类型</th>
                            <th>项目成绩</th>
                            <th>项目得分</th>
                        </tr>
                        </thead>

                        <tbody>
                        <tr th:each="score:${scoreDefault}">
                            <td th:text="${scoreStat.index+1}"></td>
                            <td th:text="${score.student.getId()}"></td>
                            <td th:text="${score.student.getName()}"></td>
                            <td th:text="${score.student.getGender()=='M'?'男':'女'}"></td>
                            <td th:text="${score.student.getSchool()}"></td>
                            <td th:text="${score.sports.getSportsId()}"></td>
                            <td th:text="${score.sports.getSportsName()}"></td>
                            <td th:text="${score.sports.getSportsType()=='M_sports'?'男子项目':'女子项目'}"></td>
                            <td th:text="${score.getGrade()}"></td>
                            <td th:text="${score.getScore()}"></td>

                        </tr>

                        </tbody>
                    </table>
                </div>

            </div>
        </div>
    </div>
</div>
</body>
<script src="https://cdn.jsdelivr.net/npm/jquery@1.12.4/dist/jquery.min.js"></script>
<script type="text/javascript">
</script>

<script>
    layui.use(['laydate', 'form'],
        function() {
            var laydate = layui.laydate;

            //执行一个laydate实例
            laydate.render({
                elem: '#start' //指定元素
            });

            //执行一个laydate实例
            laydate.render({
                elem: '#end' //指定元素
            });
        });



</script>

</html>